USE [RD_GLMart]
GO

/****** Object:  Index [PK_GL_Star_SubLedger]    Script Date: 07/02/2010 09:41:14 ******/
ALTER TABLE [dbo].[GL_Star_SubLedger] ADD  CONSTRAINT [PK_GL_Star_SubLedger] PRIMARY KEY CLUSTERED 
(
	[SubLedger] ASC,
	[SubLedgerType] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO


USE [RD_GLMart]
GO

/****** Object:  Index [IX_SubLedger_SubLedgerID]    Script Date: 07/02/2010 09:41:11 ******/
CREATE NONCLUSTERED INDEX [IX_SubLedger_SubLedgerID] ON [dbo].[GL_Star_SubLedger] 
(
	[SubLedgerID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_184]    Script Date: 07/02/2010 09:41:11 ******/
CREATE NONCLUSTERED INDEX [missing_index_184] ON [dbo].[GL_Star_SubLedger] 
(
	[SourceID] ASC,
	[SubLedgerType] ASC
)
INCLUDE ( [SubLedger]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO



